[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '143' >
4 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 27.1394 | 1987-03-06 | Human Resources | paula0@adventure-works.com | Paula Barreto de Mattos | 523-555-0175 | 535145551 | Paula | F | 2019-12-30 | Barreto de Mattos | adventure-works\paula0 | M | M | 143 | 2 | 523-555-0175 | 1 | 47 | 2019-12-30 | Current | Human Resources Manager | 54 | |
106 | 13.4615 | 1975-07-15 | Finance | david5@adventure-works.com | David Barber | 477-555-0132 | 231203233 | David | M | 2020-02-05 | Barber | adventure-works\david5 | S | M | 143 | 2 | 477-555-0132 | 48 | 2020-02-05 | Current | Assistant to the Chief Financial Officer | 56 | ||
73 | 43.2692 | 1995-11-04 | Finance | wendy0@adventure-works.com | Wendy Kahn | 248-555-0134 | 121491555 | Wendy | F | 2020-01-18 | Kahn | adventure-works\wendy0 | S | Beth | 143 | 2 | 248-555-0134 | 1 | 47 | 2020-01-18 | Current | Finance Manager | 55 | |
142 | 34.7356 | 1994-07-31 | Finance | david6@adventure-works.com | David Liu | 646-555-0185 | 30845 | David | M | 2020-02-23 | Liu | adventure-works\david6 | M | J | 143 | 2 | 646-555-0185 | 1 | 48 | 2020-02-23 | Current | Accounts Manager | 57 |
Generated 2025-07-24 03:00:35.464 UTC